RetailTransactionSalesReceiptImage

Entity Definition

Logical Name : RetailTransactionSalesReceiptImage
Physical Name : DO_RTL_TRN_SLS_RCT_IMG

This entity identifies and describes a sales receipt digital image that is an exact duplicate of a paper sales receipt printed from the retail transaction. As used here, a digital image is a raster or vector representation of a sales receipt with no retrievable business data. The retrievable business data is already captured in the RetailTransaction and its component entity types. NOTE that the parameters, message structures, methods and other components of a digital receipt generation process are NOT reflected in this entity. Its sole purpose is to provide a way to access the image object connected to the related RetailTransaction.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32) RetailTransaction(TR_RTL)
CreateDateTime The time-date this RetailTransactionSalesReceipImage instance was created. Note that sales receipts MAY NOT be altered after a transaction is posted. If necessary the transaction may be VOIDED and recreated. DT_CRT_DT_TM Datetime datetime
SalesReciptImageFileURI Universal Resource Identifier that points to the source where the retail sales receipt is stored. URI_SLS_RCT_IMG_FLE DescriptionShort varchar(255)
SalesReceiptImageBlob A binary large object used to store a sales receipt image within the database. This is provided as an option for really small receipts or retailers with low sales receipt volume. As a rule, retailers will use the URI attribute to reference the digital image file which resides outside the relational database. BM_SLS_RCT_IMG Blob varbinary

Relationships

Parent Entity Verb Phrase Child Entity
RetailTransaction image rendered as RetailTransactionSalesReceiptImage

No Logical Views for RetailTransactionSalesReceiptImage